package com.situ.team5.kzq.recruit.dao;

import com.situ.team5.pojo.EngageResume;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;

import java.util.List;
import java.util.Map;

@Mapper
public interface LyGlDAO {
    @Select("select c.major_name,f.major_kind_name,m.* from  engage_resume m inner join" +
            " config_major c on m.human_major_id=c.major_id inner join " +
            " config_major_kind f on c.major_kind_id=f.major_kind_id"+
            " where jl_status=4 ")
    List<Map> register_listSelectAll();



    @Select("select c.major_name,f.major_kind_name,m.* from  engage_resume m inner join" +
            " config_major c on m.human_major_id=c.major_id inner join " +
            " config_major_kind f on c.major_kind_id=f.major_kind_id"+
            " where jl_status=#{value} ")
    List<Map> register_listSelectAll_sp(int id);
}
